CREATE TABLE [dbo].[MessageConfig]
(
[KeyCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Language] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Value] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TypeId] [int] NULL,
[CreatedDate] [datetime] NOT NULL CONSTRAINT [DF_MessageConfig_CreatedDate] DEFAULT (getdate()),
[UpdatedDate] [datetime] NOT NULL CONSTRAINT [DF_MessageConfig_UpdatedDate] DEFAULT (getdate()),
[CreatedUser] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UpdatedUser] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
ALTER TABLE [dbo].[MessageConfig] ADD 
CONSTRAINT [PK_MessageConfig] PRIMARY KEY CLUSTERED  ([KeyCode], [Language]) ON [PRIMARY]

GO
EXEC sp_addextendedproperty N'MS_Description', N'Mã ngôn ngữ: vi-vn, en-us', 'SCHEMA', N'dbo', 'TABLE', N'MessageConfig', 'COLUMN', N'Language'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Loại message. Hiện tại chưa có, sau này sẽ định nghĩa', 'SCHEMA', N'dbo', 'TABLE', N'MessageConfig', 'COLUMN', N'TypeId'
GO
